Editing Index General

Table Name
The table that contains the index.

Unique
An unique index indicates that no two rows of a table have duplicate values in the key columns.

Fields

Field(s) Name
To define the field.

Collate(s)
To define a collating sequence used for text entries in that column. The default collating sequence is the collating sequence defined for that column.

BINARY
Compares string data using memcmp(), regardless of text encoding.

NOCASE
The same as binary, except the 26 upper case characters of ASCII are folded to their lower case equivalents before the comparison is performed. Note that only ASCII characters are case folded. SQLite does not attempt to do full UTF case folding due to the size of the tables required.

RTRIM
The same as binary, except that trailing space characters are ignored.

Note: Support in SQLite 3.

Order(s)
To indicate sort order - ascending "ASC" or descending "DESC".